Project Profile

Dataset statistics

Number of variables	15
Number of observations	113167
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	20.5 MiB
Average record size in memory	189.9 B

Variable types

Numeric	14
Categorical	1

Alerts

`acq_date` has a high cardinality: 4037 distinct values	High cardinality
`latitude` is highly correlated with `longitude` and 1 other fields	High correlation
`longitude` is highly correlated with `latitude` and 1 other fields	High correlation
`brightness` is highly correlated with `confidence`	High correlation
`confidence` is highly correlated with `brightness`	High correlation
`elevation` is highly correlated with `latitude` and 1 other fields	High correlation
`max_temp` is highly correlated with `min_temp`	High correlation
`min_temp` is highly correlated with `max_temp`	High correlation
`latitude` is highly correlated with `longitude`	High correlation
`longitude` is highly correlated with `latitude`	High correlation
`brightness` is highly correlated with `confidence`	High correlation
`confidence` is highly correlated with `brightness`	High correlation
`max_temp` is highly correlated with `min_temp`	High correlation
`min_temp` is highly correlated with `max_temp` and 1 other fields	High correlation
`pressure` is highly correlated with `min_temp`	High correlation
`brightness` is highly correlated with `confidence`	High correlation
`confidence` is highly correlated with `brightness`	High correlation
`max_temp` is highly correlated with `min_temp`	High correlation
`min_temp` is highly correlated with `max_temp`	High correlation
`latitude` is highly correlated with `longitude` and 1 other fields	High correlation
`longitude` is highly correlated with `latitude` and 2 other fields	High correlation
`brightness` is highly correlated with `confidence`	High correlation
`confidence` is highly correlated with `brightness`	High correlation
`elevation` is highly correlated with `latitude` and 2 other fields	High correlation
`solar_radiation` is highly correlated with `humidity`	High correlation
`max_temp` is highly correlated with `min_temp` and 1 other fields	High correlation
`min_temp` is highly correlated with `max_temp`	High correlation
`pressure` is highly correlated with `max_temp`	High correlation
`humidity` is highly correlated with `longitude` and 2 other fields	High correlation
`df_index` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`brightness` has 55828 (49.3%) zeros	Zeros
`confidence` has 56730 (50.1%) zeros	Zeros
`elevation` has 10312 (9.1%) zeros	Zeros
`precipitation` has 83660 (73.9%) zeros	Zeros

Reproduction

Analysis started	2022-02-19 01:07:44.417211
Analysis finished	2022-02-19 01:08:49.362313
Duration	1 minute and 4.95 seconds
Software version	pandas-profiling v3.1.1
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct	113167
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	59981.47299

Minimum	0
Maximum	119999
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	884.2 KiB

Quantile statistics

Minimum	0
5-th percentile	6013.3
Q1	30006.5
median	59918
Q3	90017.5
95-th percentile	113999.7
Maximum	119999
Range	119999
Interquartile range (IQR)	60011

Descriptive statistics

Standard deviation	34634.73488
Coefficient of variation (CV)	0.5774238803
Kurtosis	-1.200955517
Mean	59981.47299
Median Absolute Deviation (MAD)	30006
Skewness	0.00165729683
Sum	6787923354
Variance	1199564860
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
80018	1	< 0.1%
80029	1	< 0.1%
80028	1	< 0.1%
80027	1	< 0.1%
80026	1	< 0.1%
80025	1	< 0.1%
80024	1	< 0.1%
80023	1	< 0.1%
80022	1	< 0.1%
Other values (113157)	113157	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
119999	1	< 0.1%
119998	1	< 0.1%
119997	1	< 0.1%
119996	1	< 0.1%
119995	1	< 0.1%
119994	1	< 0.1%
119993	1	< 0.1%
119992	1	< 0.1%
119991	1	< 0.1%
119990	1	< 0.1%

latitude
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	49415
Distinct (%)	43.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.36434835

Minimum	19.02689934
Maximum	70.30950165
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.2 KiB

Quantile statistics

Minimum	19.02689934
5-th percentile	28.85108967
Q1	32.11719894
median	35.65330124
Q3	41.3871994
95-th percentile	48.44680023
Maximum	70.30950165
Range	51.28260231
Interquartile range (IQR)	9.270000458

Descriptive statistics

Standard deviation	7.753203256
Coefficient of variation (CV)	0.2075027024
Kurtosis	3.33444905
Mean	37.36434835
Median Absolute Deviation (MAD)	4.192001343
Skewness	1.407421965
Sum	4228411.21
Variance	60.11216073
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.6332016	18	< 0.1%
42.68249893	16	< 0.1%
41.63579941	14	< 0.1%
41.63199997	14	< 0.1%
19.40690041	14	< 0.1%
41.46269989	14	< 0.1%
33.41379929	12	< 0.1%
19.40620041	12	< 0.1%
33.41870117	12	< 0.1%
33.41770172	12	< 0.1%
Other values (49405)	113029	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19.02689934	1	< 0.1%
19.27969933	2	< 0.1%
19.32929993	2	< 0.1%
19.32990074	2	< 0.1%
19.33160019	2	< 0.1%
19.33309937	2	< 0.1%
19.33370018	2	< 0.1%
19.33390045	2	< 0.1%
19.33510017	2	< 0.1%
19.33539963	2	< 0.1%

Value	Count	Frequency (%)
70.30950165	2	< 0.1%
70.21620178	2	< 0.1%
70.14710236	2	< 0.1%
69.42960358	1	< 0.1%
69.05329895	1	< 0.1%
69.05079651	1	< 0.1%
69.05020142	1	< 0.1%
68.98560333	2	< 0.1%
68.47769928	1	< 0.1%
68.46459961	1	< 0.1%

longitude
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	52912
Distinct (%)	46.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-99.70368883

Minimum	-166.0917053
Maximum	-67.0042038
Zeros	0
Zeros (%)	0.0%
Negative	113167
Negative (%)	100.0%
Memory size	884.2 KiB

Quantile statistics

Minimum	-166.0917053
5-th percentile	-124.0730972
Q1	-111.8425522
median	-94.92340088
Q3	-86.25489807
95-th percentile	-80.42549896
Maximum	-67.0042038
Range	99.08750153
Interquartile range (IQR)	25.58765411

Descriptive statistics

Standard deviation	17.94213104
Coefficient of variation (CV)	-0.1799545358
Kurtosis	1.541401073
Mean	-99.70368883
Median Absolute Deviation (MAD)	10.36230469
Skewness	-1.28612591
Sum	-11283167.35
Variance	321.9200662
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.13400269	12	< 0.1%
-88.01499939	12	< 0.1%
-111.594101	11	< 0.1%
-111.5888977	10	< 0.1%
-87.1339035	10	< 0.1%
-88.01029968	10	< 0.1%
-88.01300049	10	< 0.1%
-155.2812958	10	< 0.1%
-81.67569733	10	< 0.1%
-81.6760025	10	< 0.1%
Other values (52902)	113062	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-166.0917053	2	< 0.1%
-164.6549988	1	< 0.1%
-164.459198	2	< 0.1%
-164.405304	2	< 0.1%
-164.3726959	2	< 0.1%
-164.3652954	2	< 0.1%
-164.3596954	2	< 0.1%
-164.2752075	2	< 0.1%
-164.2579956	2	< 0.1%
-164.1264038	2	< 0.1%

Value	Count	Frequency (%)
-67.0042038	2	< 0.1%
-67.52059937	2	< 0.1%
-67.70059967	2	< 0.1%
-67.89199829	2	< 0.1%
-68.02259827	2	< 0.1%
-68.33769989	2	< 0.1%
-68.58010101	2	< 0.1%
-68.60050201	2	< 0.1%
-68.61090088	2	< 0.1%
-68.91680145	2	< 0.1%

acq_date
Categorical

HIGH CARDINALITY

Distinct	4037
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

2/28/2015 12:00:00 AM	195
6/25/2015 12:00:00 AM	166
2/29/2020 12:00:00 AM	134
9/7/2020 12:00:00 AM	125
9/8/2020 12:00:00 AM	125
Other values (4032)	112422

Length

Max length	22
Median length	21
Mean length	20.87833909
Min length	20

Characters and Unicode

Total characters	2362739
Distinct characters	15
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	15 ?
Unique (%)	< 0.1%

Sample

1st row	4/5/2021 12:00:00 AM
2nd row	3/5/2021 12:00:00 AM
3rd row	4/22/2013 12:00:00 AM
4th row	3/22/2013 12:00:00 AM
5th row	4/8/2020 12:00:00 AM

Common Values

Value	Count	Frequency (%)
2/28/2015 12:00:00 AM	195	0.2%
6/25/2015 12:00:00 AM	166	0.1%
2/29/2020 12:00:00 AM	134	0.1%
9/7/2020 12:00:00 AM	125	0.1%
9/8/2020 12:00:00 AM	125	0.1%
4/1/2021 12:00:00 AM	125	0.1%
2/28/2021 12:00:00 AM	123	0.1%
6/23/2015 12:00:00 AM	119	0.1%
2/28/2014 12:00:00 AM	118	0.1%
9/9/2020 12:00:00 AM	118	0.1%
Other values (4027)	111819	98.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
12:00:00	113167	33.3%
am	113167	33.3%
2/28/2015	195	0.1%
6/25/2015	166	< 0.1%
2/29/2020	134	< 0.1%
9/7/2020	125	< 0.1%
9/8/2020	125	< 0.1%
4/1/2021	125	< 0.1%
2/28/2021	123	< 0.1%
6/23/2015	119	< 0.1%
Other values (4029)	112055	33.0%

Most occurring characters

Value	Count	Frequency (%)
0	598669	25.3%
2	321647	13.6%
1	308698	13.1%
/	226334	9.6%
	226334	9.6%
:	226334	9.6%
A	113167	4.8%
M	113167	4.8%
3	38845	1.6%
7	34409	1.5%
Other values (5)	155135	6.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1457403	61.7%
Other Punctuation	452668	19.2%
Space Separator	226334	9.6%
Uppercase Letter	226334	9.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	598669	41.1%
2	321647	22.1%
1	308698	21.2%
3	38845	2.7%
7	34409	2.4%
8	33675	2.3%
9	32263	2.2%
6	29927	2.1%
4	29874	2.0%
5	29396	2.0%

Other Punctuation

Value	Count	Frequency (%)
/	226334	50.0%
:	226334	50.0%

Uppercase Letter

Value	Count	Frequency (%)
A	113167	50.0%
M	113167	50.0%

Space Separator

Value	Count	Frequency (%)
	226334	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2136405	90.4%
Latin	226334	9.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	598669	28.0%
2	321647	15.1%
1	308698	14.4%
/	226334	10.6%
	226334	10.6%
:	226334	10.6%
3	38845	1.8%
7	34409	1.6%
8	33675	1.6%
9	32263	1.5%
Other values (3)	89197	4.2%

Latin

Value	Count	Frequency (%)
A	113167	50.0%
M	113167	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2362739	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	598669	25.3%
2	321647	13.6%
1	308698	13.1%
/	226334	9.6%
	226334	9.6%
:	226334	9.6%
A	113167	4.8%
M	113167	4.8%
3	38845	1.6%
7	34409	1.5%
Other values (5)	155135	6.6%

brightness
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	4048
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	155.7244602

Minimum	0
Maximum	454.4499969
Zeros	55828
Zeros (%)	49.3%
Negative	0
Negative (%)	0.0%
Memory size	884.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	290.0500031
Q3	305.4000092
95-th percentile	321.4499969
Maximum	454.4499969
Range	454.4499969
Interquartile range (IQR)	305.4000092

Descriptive statistics

Standard deviation	153.9131969
Coefficient of variation (CV)	0.9883687938
Kurtosis	-1.983785855
Mean	155.7244602
Median Absolute Deviation (MAD)	56.6499939
Skewness	-0.01618842497
Sum	17622869.99
Variance	23689.27219
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	55828	49.3%
303.75	131	0.1%
304.25	131	0.1%
301.5	129	0.1%
305.75	129	0.1%
303.5	128	0.1%
297.75	126	0.1%
302.8000031	126	0.1%
300.75	125	0.1%
300.5	125	0.1%
Other values (4038)	56189	49.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	55828	49.3%
282.8000031	1	< 0.1%
282.9499969	1	< 0.1%
283.8500061	1	< 0.1%
283.9499969	1	< 0.1%
284.0500031	1	< 0.1%
284.1000061	2	< 0.1%
284.1999969	1	< 0.1%
284.25	1	< 0.1%
284.3500061	1	< 0.1%

Value	Count	Frequency (%)
454.4499969	1	< 0.1%
453.8000031	1	< 0.1%
452.75	1	< 0.1%
452.6999969	1	< 0.1%
451.25	1	< 0.1%
450.9000092	1	< 0.1%
450.4499969	1	< 0.1%
450.1999969	2	< 0.1%
449.3000031	1	< 0.1%
445.5500031	1	< 0.1%

confidence
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	101
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.28904186

Minimum	0
Maximum	100
Zeros	56730
Zeros (%)	50.1%
Negative	0
Negative (%)	0.0%
Memory size	884.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	65
95-th percentile	93
Maximum	100
Range	100
Interquartile range (IQR)	65

Descriptive statistics

Standard deviation	35.34490287
Coefficient of variation (CV)	1.094640808
Kurtosis	-1.408391289
Mean	32.28904186
Median Absolute Deviation (MAD)	0
Skewness	0.4297878162
Sum	3654054
Variance	1249.262159
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	56730	50.1%
100	3553	3.1%
63	1224	1.1%
62	1206	1.1%
61	1193	1.1%
65	1156	1.0%
68	1151	1.0%
64	1140	1.0%
66	1139	1.0%
59	1116	1.0%
Other values (91)	43559	38.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	56730	50.1%
1	2	< 0.1%
2	5	< 0.1%
3	11	< 0.1%
4	14	< 0.1%
5	14	< 0.1%
6	20	< 0.1%
7	30	< 0.1%
8	37	< 0.1%
9	43	< 0.1%

Value	Count	Frequency (%)
100	3553	3.1%
99	256	0.2%
98	277	0.2%
97	292	0.3%
96	312	0.3%
95	333	0.3%
94	456	0.4%
93	378	0.3%
92	379	0.3%
91	439	0.4%

elevation
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	2988
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	461.6968551

Minimum	-67
Maximum	3588
Zeros	10312
Zeros (%)	9.1%
Negative	124
Negative (%)	0.1%
Memory size	884.2 KiB

Quantile statistics

Minimum	-67
5-th percentile	0
Q1	53
median	185
Q3	530
95-th percentile	1965
Maximum	3588
Range	3655
Interquartile range (IQR)	477

Descriptive statistics

Standard deviation	640.3855877
Coefficient of variation (CV)	1.387026099
Kurtosis	2.795833258
Mean	461.6968551
Median Absolute Deviation (MAD)	166
Skewness	1.867905143
Sum	52248848
Variance	410093.7009
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10312	9.1%
11	701	0.6%
12	606	0.5%
5	569	0.5%
6	555	0.5%
10	539	0.5%
7	506	0.4%
9	481	0.4%
4	425	0.4%
73	421	0.4%
Other values (2978)	98052	86.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-67	2	< 0.1%
-66	2	< 0.1%
-59	2	< 0.1%
-54	2	< 0.1%
-53	2	< 0.1%
-52	2	< 0.1%
-49	2	< 0.1%
-44	2	< 0.1%
-42	2	< 0.1%
-41	6	< 0.1%

Value	Count	Frequency (%)
3588	2	< 0.1%
3545	2	< 0.1%
3519	2	< 0.1%
3476	2	< 0.1%
3467	2	< 0.1%
3454	2	< 0.1%
3413	2	< 0.1%
3404	2	< 0.1%
3389	2	< 0.1%
3377	4	< 0.1%

precipitation
Real number (ℝ_≥0)

ZEROS

Distinct	3556
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.561878816

Minimum	0
Maximum	268.6499939
Zeros	83660
Zeros (%)	73.9%
Negative	0
Negative (%)	0.0%
Memory size	884.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.009999999776
95-th percentile	10.10999966
Maximum	268.6499939
Range	268.6499939
Interquartile range (IQR)	0.009999999776

Descriptive statistics

Standard deviation	6.155908974
Coefficient of variation (CV)	3.941348658
Kurtosis	120.5330578
Mean	1.561878816
Median Absolute Deviation (MAD)	0
Skewness	8.191279937
Sum	176753.1399
Variance	37.8952153
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	83660	73.9%
0.009999999776	3556	3.1%
0.01999999955	1512	1.3%
0.02999999933	919	0.8%
0.03999999911	700	0.6%
0.05000000075	536	0.5%
0.05999999866	467	0.4%
0.0700000003	360	0.3%
0.07999999821	317	0.3%
0.09000000358	267	0.2%
Other values (3546)	20873	18.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	83660	73.9%
0.009999999776	3556	3.1%
0.01999999955	1512	1.3%
0.02999999933	919	0.8%
0.03999999911	700	0.6%
0.05000000075	536	0.5%
0.05999999866	467	0.4%
0.0700000003	360	0.3%
0.07999999821	317	0.3%
0.09000000358	267	0.2%

Value	Count	Frequency (%)
268.6499939	1	< 0.1%
182.0599976	1	< 0.1%
171.7899933	1	< 0.1%
161.9299927	1	< 0.1%
153.7700043	1	< 0.1%
145.8399963	1	< 0.1%
140.2299957	1	< 0.1%
139.0500031	1	< 0.1%
132.0200043	1	< 0.1%
130.9100037	1	< 0.1%

solar_radiation
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	38393
Distinct (%)	33.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	376.8661961

Minimum	0
Maximum	1138.5
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	884.2 KiB

Quantile statistics

Minimum	0
5-th percentile	176.5329971
Q1	308.0749969
median	389.2200012
Q3	456.6000061
95-th percentile	530.9000244
Maximum	1138.5
Range	1138.5
Interquartile range (IQR)	148.5250092

Descriptive statistics

Standard deviation	108.1562769
Coefficient of variation (CV)	0.2869885335
Kurtosis	0.1462103876
Mean	376.8661961
Median Absolute Deviation (MAD)	73.41000366
Skewness	-0.4423704553
Sum	42648816.81
Variance	11697.78024
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
496.8999939	25	< 0.1%
394.1000061	25	< 0.1%
394.8999939	23	< 0.1%
328.8999939	23	< 0.1%
444.7999878	23	< 0.1%
426.3999939	23	< 0.1%
355.6000061	23	< 0.1%
337.2000122	22	< 0.1%
394.3999939	22	< 0.1%
448.1000061	21	< 0.1%
Other values (38383)	112937	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
3	4	< 0.1%
5	1	< 0.1%
6.699999809	1	< 0.1%
8	1	< 0.1%
8.5	1	< 0.1%
11.35999966	1	< 0.1%
11.40999985	1	< 0.1%
11.96000004	1	< 0.1%

Value	Count	Frequency (%)
1138.5	1	< 0.1%
1130.699951	1	< 0.1%
1129.900024	1	< 0.1%
1129.099976	1	< 0.1%
1125.300049	2	< 0.1%
1080.900024	1	< 0.1%
932	1	< 0.1%
907.2999878	1	< 0.1%
906.5	1	< 0.1%
906.4000244	1	< 0.1%

max_temp
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	123
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	75.62136489

Minimum	-7
Maximum	120
Zeros	1
Zeros (%)	< 0.1%
Negative	4
Negative (%)	< 0.1%
Memory size	884.2 KiB

Quantile statistics

Minimum	-7
5-th percentile	47
Q1	66
median	77
Q3	88
95-th percentile	97
Maximum	120
Range	127
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	15.72790035
Coefficient of variation (CV)	0.2079822332
Kurtosis	0.3144021522
Mean	75.62136489
Median Absolute Deviation (MAD)	11
Skewness	-0.6250560348
Sum	8557843
Variance	247.3668493
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
84	3483	3.1%
82	3326	2.9%
90	3270	2.9%
81	3114	2.8%
86	3093	2.7%
88	2967	2.6%
79	2958	2.6%
91	2957	2.6%
72	2911	2.6%
70	2866	2.5%
Other values (113)	82222	72.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-7	1	< 0.1%
-2	2	< 0.1%
-1	1	< 0.1%
0	1	< 0.1%
1	5	< 0.1%
2	3	< 0.1%
3	1	< 0.1%
4	2	< 0.1%
5	2	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
120	1	< 0.1%
118	3	< 0.1%
117	6	< 0.1%
116	4	< 0.1%
115	19	< 0.1%
114	8	< 0.1%
113	49	< 0.1%
112	9	< 0.1%
111	65	0.1%
110	47	< 0.1%

min_temp
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	129
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.71154135

Minimum	-23
Maximum	252
Zeros	13
Zeros (%)	< 0.1%
Negative	127
Negative (%)	0.1%
Memory size	884.2 KiB

Quantile statistics

Minimum	-23
5-th percentile	28
Q1	42
median	54
Q3	64
95-th percentile	75
Maximum	252
Range	275
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	15.2262542
Coefficient of variation (CV)	0.288859969
Kurtosis	2.6648999
Mean	52.71154135
Median Absolute Deviation (MAD)	11
Skewness	-0.06279060746
Sum	5965207
Variance	231.8388169
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
54	3712	3.3%
55	3505	3.1%
57	3400	3.0%
48	3298	2.9%
59	3246	2.9%
52	3227	2.9%
61	3221	2.8%
63	3200	2.8%
46	3195	2.8%
50	3117	2.8%
Other values (119)	80046	70.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-23	1	< 0.1%
-21	2	< 0.1%
-20	1	< 0.1%
-18	3	< 0.1%
-17	3	< 0.1%
-16	2	< 0.1%
-15	2	< 0.1%
-14	4	< 0.1%
-13	3	< 0.1%
-12	3	< 0.1%

Value	Count	Frequency (%)
252	1	< 0.1%
244	2	< 0.1%
243	5	< 0.1%
241	1	< 0.1%
232	2	< 0.1%
221	1	< 0.1%
203	1	< 0.1%
199	1	< 0.1%
198	2	< 0.1%
189	3	< 0.1%

pressure
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	45429
Distinct (%)	40.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1307.859446

Minimum	0
Maximum	3875.02002
Zeros	13
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	884.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1002.599976
Q1	1015.599976
median	1024
Q3	1429.585022
95-th percentile	2613.66792
Maximum	3875.02002
Range	3875.02002
Interquartile range (IQR)	413.9850464

Descriptive statistics

Standard deviation	549.3876093
Coefficient of variation (CV)	0.420066247
Kurtosis	1.652808829
Mean	1307.859446
Median Absolute Deviation (MAD)	13
Skewness	1.563571233
Sum	148006530
Variance	301826.7452
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1017	566	0.5%
1016	565	0.5%
1019	558	0.5%
1015	512	0.5%
1021	509	0.4%
1018	503	0.4%
1020	485	0.4%
1023	480	0.4%
1017.5	470	0.4%
1015.5	461	0.4%
Other values (45419)	108058	95.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13	< 0.1%
58.43000031	1	< 0.1%
63.77000046	1	< 0.1%
75.15000153	1	< 0.1%
75.83999634	1	< 0.1%
83.04000092	1	< 0.1%
83.76000214	1	< 0.1%
88.29000092	1	< 0.1%
88.31999969	1	< 0.1%
89.33000183	1	< 0.1%

Value	Count	Frequency (%)
3875.02002	1	< 0.1%
3772.620117	1	< 0.1%
3704.070068	1	< 0.1%
3670.570068	1	< 0.1%
3667.810059	1	< 0.1%
3662.360107	1	< 0.1%
3643.070068	1	< 0.1%
3634.810059	1	< 0.1%
3631.929932	1	< 0.1%
3630.580078	1	< 0.1%

humidity
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	8612
Distinct (%)	7.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	62.44548765

Minimum	0
Maximum	100
Zeros	43
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	884.2 KiB

Quantile statistics

Minimum	0
5-th percentile	30.40999985
Q1	51.56999969
median	64.73000336
Q3	75.02999878
95-th percentile	87.52999878
Maximum	100
Range	100
Interquartile range (IQR)	23.45999908

Descriptive statistics

Standard deviation	17.27081706
Coefficient of variation (CV)	0.2765743004
Kurtosis	-0.06259896518
Mean	62.44548765
Median Absolute Deviation (MAD)	11.48999786
Skewness	-0.5279682642
Sum	7066768.501
Variance	298.2811219
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
65	533	0.5%
59	473	0.4%
68	470	0.4%
62	447	0.4%
57	389	0.3%
58	374	0.3%
64	365	0.3%
63	364	0.3%
70	362	0.3%
61	362	0.3%
Other values (8602)	109028	96.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	43	< 0.1%
4.989999771	1	< 0.1%
5.840000153	1	< 0.1%
6	1	< 0.1%
6.130000114	1	< 0.1%
6.150000095	1	< 0.1%
6.21999979	1	< 0.1%
6.440000057	1	< 0.1%
6.630000114	1	< 0.1%
6.679999828	2	< 0.1%

Value	Count	Frequency (%)
100	17	< 0.1%
99.98000336	2	< 0.1%
99.95999908	1	< 0.1%
99.93000031	1	< 0.1%
99.91999817	2	< 0.1%
99.91000366	2	< 0.1%
99.90000153	1	< 0.1%
99.88999939	1	< 0.1%
99.87999725	1	< 0.1%
99.87000275	1	< 0.1%

wind_speed
Real number (ℝ_≥0)

Distinct	2275
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.42003687

Minimum	0
Maximum	92.19999695
Zeros	16
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	884.2 KiB

Quantile statistics

Minimum	0
5-th percentile	5.699999809
Q1	8.699999809
median	11.39999962
Q3	15.10000038
95-th percentile	22.20000076
Maximum	92.19999695
Range	92.19999695
Interquartile range (IQR)	6.400000572

Descriptive statistics

Standard deviation	5.271979985
Coefficient of variation (CV)	0.424473779
Kurtosis	3.239147241
Mean	12.42003687
Median Absolute Deviation (MAD)	3.199999809
Skewness	1.182350619
Sum	1405538.312
Variance	27.79377296
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.30000019	2101	1.9%
9.199999809	2078	1.8%
11.39999962	2038	1.8%
8.100000381	1753	1.5%
12.80000019	1724	1.5%
13.89999962	1637	1.4%
6.900000095	1405	1.2%
15	1345	1.2%
16.10000038	1264	1.1%
17.20000076	1046	0.9%
Other values (2265)	96776	85.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	16	< 0.1%
0.1000000015	2	< 0.1%
0.3000000119	3	< 0.1%
0.400000006	3	< 0.1%
0.6000000238	2	< 0.1%
0.6999999881	1	< 0.1%
0.8000000119	4	< 0.1%
0.9196293354	6	< 0.1%
0.9693390727	1	< 0.1%
1	2	< 0.1%

Value	Count	Frequency (%)
92.19999695	1	< 0.1%
86.80000305	1	< 0.1%
82.40000153	1	< 0.1%
57.5	1	< 0.1%
54.59999847	1	< 0.1%
54.09999847	1	< 0.1%
52.90000153	1	< 0.1%
52.70000076	1	< 0.1%
51.70000076	1	< 0.1%
51.40000153	1	< 0.1%

winddir
Real number (ℝ_≥0)

Distinct	19864
Distinct (%)	17.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	185.9792182

Minimum	0
Maximum	360
Zeros	32
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	884.2 KiB

Quantile statistics

Minimum	0
5-th percentile	60.7028183
Q1	129.1000061
median	183.6999969
Q3	241.5617523
95-th percentile	317.0498352
Maximum	360
Range	360
Interquartile range (IQR)	112.4617462

Descriptive statistics

Standard deviation	77.17927915
Coefficient of variation (CV)	0.4149887278
Kurtosis	-0.7150800723
Mean	185.9792182
Median Absolute Deviation (MAD)	56.19999695
Skewness	0.08179573841
Sum	21046710.18
Variance	5956.64113
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
170	101	0.1%
180	100	0.1%
190	97	0.1%
220	90	0.1%
212.7962341	85	0.1%
257.9929199	84	0.1%
150	84	0.1%
153.5	84	0.1%
225	83	0.1%
157.5	79	0.1%
Other values (19854)	112280	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	32	< 0.1%
0.4783861935	2	< 0.1%
0.5	1	< 0.1%
0.8124922514	1	< 0.1%
1.496080399	1	< 0.1%
2	1	< 0.1%
2.555440426	1	< 0.1%
3	1	< 0.1%
3.5	5	< 0.1%
4.400000095	1	< 0.1%

Value	Count	Frequency (%)
360	5	< 0.1%
359.9733276	1	< 0.1%
359.9684448	1	< 0.1%
359.925354	1	< 0.1%
359.9219971	4	< 0.1%
359.8702393	6	< 0.1%
359.8641663	2	< 0.1%
359.8392029	1	< 0.1%
359.7921143	1	< 0.1%
359.6923523	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	latitude	longitude	acq_date	brightness	confidence	elevation	precipitation	solar_radiation	max_temp	min_temp	pressure	humidity	wind_speed	winddir
0	0	34.327702	-82.290001	4/5/2021 12:00:00 AM	302.000000	51	0	0.00	229.699997	81	48	1020.000000	47.240002	9.0	210.441437
1	1	34.327702	-82.290001	3/5/2021 12:00:00 AM	0.000000	0	0	0.00	265.600006	62	38	1018.299988	40.529999	7.5	70.500000
2	2	31.697500	-92.606697	4/22/2013 12:00:00 AM	303.899994	53	46	0.01	536.090027	81	57	1056.560059	66.480003	8.8	56.099998
3	3	31.697500	-92.606697	3/22/2013 12:00:00 AM	0.000000	0	46	0.01	397.000000	78	56	1249.189941	75.370003	10.3	119.800003
4	6	41.711800	-85.824799	4/8/2020 12:00:00 AM	300.500000	52	235	3.14	369.299988	73	50	1112.300049	75.360001	16.9	338.766754
5	7	41.711800	-85.824799	3/8/2020 12:00:00 AM	0.000000	0	235	0.00	421.500000	61	37	1025.500000	41.880001	20.1	202.800003
6	8	32.430302	-82.679901	3/16/2017 12:00:00 AM	295.000000	39	80	0.00	486.119995	57	30	1014.280029	48.000000	9.8	290.692566
7	9	32.430302	-82.679901	2/16/2017 12:00:00 AM	0.000000	0	80	0.00	382.850006	66	38	751.270020	47.830002	9.2	301.299988
8	10	30.625000	-88.917801	11/20/2020 12:00:00 AM	301.050003	63	31	0.00	323.140015	77	63	1279.060059	77.790001	11.8	79.186386
9	11	30.625000	-88.917801	10/20/2020 12:00:00 AM	0.000000	0	31	0.00	349.600006	86	66	2116.090088	80.970001	11.0	74.199997

Last rows

	df_index	latitude	longitude	acq_date	brightness	confidence	elevation	precipitation	solar_radiation	max_temp	min_temp	pressure	humidity	wind_speed	winddir
113157	119990	27.770700	-80.922897	4/19/2018 12:00:00 AM	319.349991	82	23	0.00	564.650024	88	68	1026.050049	65.540001	13.200000	194.000000
113158	119991	27.770700	-80.922897	3/19/2018 12:00:00 AM	0.000000	0	23	0.08	482.369995	87	63	1100.280029	69.940002	10.100000	235.100006
113159	119992	65.307297	-154.730698	7/1/2015 12:00:00 AM	309.550003	85	185	0.00	277.809998	70	55	1019.070007	73.000000	9.200000	253.000000
113160	119993	65.307297	-154.730698	6/1/2015 12:00:00 AM	0.000000	0	185	0.00	328.260010	63	37	1015.200012	33.189999	17.200001	85.199997
113161	119994	31.988600	-91.519997	8/3/2018 12:00:00 AM	315.399994	43	18	0.31	494.619995	93	70	2102.879883	78.459999	8.100000	110.892326
113162	119995	31.988600	-91.519997	7/3/2018 12:00:00 AM	0.000000	0	18	7.91	296.399994	92	75	2840.300049	82.900002	17.200001	99.199997
113163	119996	32.928001	-84.465202	3/28/2015 12:00:00 AM	298.399994	68	252	0.00	412.519989	56	37	1020.799988	51.349998	12.900000	321.851410
113164	119997	32.928001	-84.465202	2/28/2015 12:00:00 AM	0.000000	0	252	2.45	303.589996	58	35	1032.900024	60.480000	11.400000	76.699997
113165	119998	32.990601	-91.687401	10/2/2011 12:00:00 AM	308.449997	75	35	0.00	433.019989	76	44	1023.400024	62.450001	8.100000	59.000000
113166	119999	32.990601	-91.687401	9/2/2011 12:00:00 AM	0.000000	0	35	0.04	413.100006	98	71	2320.860107	62.070000	12.700000	55.000000

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows